/****** Object:  User Defined Function dbo.GetFirstGLTransactionLineKey    Script Date: 1/10/2006 9:19:58 AM ******/
CREATE   FUNCTION [dbo].[GetFirstGLTransactionLineKey]
  (@GLTransKey uniqueidentifier, @PaymentKey uniqueidentifier, @GLAccountKey uniqueidentifier, @Type nvarchar(50))
RETURNS uniqueidentifier
AS
BEGIN
    RETURN (SELECT TOP 1 GLTransactionLineKey FROM GLTransactionLine
    WHERE GLTransactionKey = @GLTransKey
        AND (PaymentKey = @PaymentKey OR @PaymentKey is null)
        AND GLAccountKey = @GLAccountKey
        AND GLEntryType = @Type)
END

GO